FaShoppingSheetLoanOptionsConfig 
Logical Entity Name  FaShoppingSheetLoanOptionsConfig 
Default Table Name  FaShoppingSheetLoanOptionsConfig 
Physical Only  NO 
Definition 
 
Note 
 

FaShoppingSheetLoanOptionsConfig Columns 
ColumnName  Domain  Datatype  NULL  Definition 
FaShoppingSheetLoanOptionsConfigId(PK)    char(10)  NO 
 
FaYearId(FK)    char(2)  NO 
 
SyCampusId(FK)    int  NO 
 
AdProgramVersionId(FK)    int  NO 
 
PerkinsLoan    char(10)  YES 
 
PerkinsLoanNA    char(10)  NO 
 
DLSubLoan    char(10)  YES 
 
DLSubLoanNA    char(10)  NO 
 
DLUnSubLoan    char(10)  YES 
 
DLUnSubLoanNA    char(10)  NO 
 
DateAdded    char(10)  NO 
 
DateLstMod    char(10)  NO 
 
UserId(FK)    int  NO 
 
ts    char(10)  NO 
 
PrivateLoan    char(10)  YES 
 
PrivateLoanNA    char(10)  NO 
 
InstLoan    char(10)  YES 
 
InstLoanNA    char(10)  NO 
 
PPlusLoan    char(10)  YES 
 
PPlusLoanNA    char(10)  NO 
 
OtherAid    char(10)  YES 
 
OtherAidNA    char(10)  NO 
 

FaShoppingSheetLoanOptionsConfig Primary and Unique Keys 
Key Name  Key Type  Keys 
UK_FaShoppingSheetLoanOptionsConfig_FaYearId_SyCampusId_AdProgramVersionId  Index  FaYearId, SyCampusId, AdProgramVersionId 
PK_FaShoppingSheetLoanOptionsConfig_FaShoppingSheetLoanOptionsConfigID  PrimaryKey  FaShoppingSheetLoanOptionsConfigId 

FaShoppingSheetLoanOptionsConfig Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdProgramVersion  Non-Identifying  One To Zero or More  FK_FaShoppingSheetLoanOptionsConfigAdProgramVersionId_AdProgramVersionAdProgramVersionId      AdProgramVersionId  NO  YES 
FaYear  Non-Identifying  One To Zero or More  FK_FaShoppingSheetLoanOptionsConfigFaYearId_FaYearFaYearId      FaYearId  NO  YES 
SyCampus  Non-Identifying  One To Zero or More  FK_FaShoppingSheetLoanOptionsConfigSyCampusId_SyCampusSyCampusId      SyCampusId  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_FaShoppingSheetLoanOptionsConfigUserId_SyStaffSyStaffId      UserId  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

FaShoppingSheetLoanOptionsConfig Check Constraints 
Check Constraint Name  CheckConstraint